<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="db" class="com.zipishu.DataBaseConnection"></jsp:useBean>

<div class="align-left">
			
				<div id="left-menu">
					<h3 class="city_info"><span>城市情报</span></h3>
					<p>
					<%
						Connection dbc1 = db.getConnection();
						Statement stmt1 = dbc1.createStatement();
						String sql1 = "select *  from area ";
						ResultSet rs1 = stmt1.executeQuery(sql1);
						while(rs1.next()){
					%>
						<tr>
						<td><a href="City_news2.jsp?areaid=<%=rs1.getInt("areaid")%>"><%=rs1.getString("areaname")%></a></td>∣
						</tr>
					<%
						}
						rs1.close();
						dbc1.close();
					%>
					</p>
					
					<h3 class="emotion_map"><span>情绪地图</span></h3>
					<p name="emotionid">
						<%	
						//Integer emotionId = 0;
						
						Connection dbc2 = db.getConnection();
						Statement stmt2 = dbc2.createStatement();
						String sql2 = "select * from emotion ";
						ResultSet rs2 = stmt2.executeQuery(sql2);
						while(rs2.next()){
						//emotionId = rs2.getInt("emotionid");
					%>
						<tr>
						<td><a href="emotion2.jsp?emotionid=<%=rs2.getInt("emotionid")%>"><%=rs2.getString("emotionname")%></a></td>∣
						</tr>
						
					<%
						}
						rs2.close();
						dbc2.close();
					%>
					</p>	
					<h3 class="les_shortcut"><span>休闲快捷</span></h3>
					<p>
					<%
						Connection dbc3 = db.getConnection();
						Statement stmt3 = dbc3.createStatement();
						String sql3 = "select * from shortcut ";
						ResultSet rs3 = stmt3.executeQuery(sql3);
						while(rs3.next()){
					%>
						<tr>
						<td><a href="shortcut2.jsp?shortid=<%=rs3.getInt("shortid")%>"><%=rs3.getString("shortname")%></a></td>∣
						</tr>
					<%
						}
						rs3.close();
						dbc3.close();
					%>
					</p>
								
					<h4 class="les_24h"><span>休闲24小时</span></h4>
					<p>
					<%
						Connection dbc4 = db.getConnection();
						Statement stmt4 = dbc4.createStatement();
						String sql4 = "select timename from bustime ";
						ResultSet rs4 = stmt4.executeQuery(sql4);
						while(rs4.next()){
					%>
						<tr>
						<td><%=rs4.getString("timename")%></td>∣
						</tr>
					<%
						}
						rs4.close();
						dbc4.close();
					%>
					
					</p>	
					<h4 class="les_ind"><span>个性休闲</span></h4>
					<p>
						最具人气的十个酒吧<br /> 
						看的到西湖的咖啡馆<br /> 
						异国风情的餐厅<br /> 
						地道杭帮的餐厅<br /> 
						明星老板主题餐厅<br /> 
						设计师主题餐厅<br /> 
						拿风景下饭的主题餐厅<br /> 
						情景文化主题餐厅<br /> 
						适合商务会餐的餐厅<br /> 
						适合闺中密友的餐厅<br /> 
						适合初次邂逅去的餐厅<br /> 
					</p>	
				</div>
				<div class="ads">
					<img src="./images/ads_1.png" />
				</div>
			</div>
			<div id="content" class="align-right">